CREATE TABLE [dbo].[OpportunityMainSales]
(
[OpportunityKey] [uniqueidentifier] NOT NULL,
[Product] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DecisionDate] [datetime] NULL,
[TimingProbability] [decimal] (12, 4) NOT NULL CONSTRAINT [DF_OpportunityMainSales_TimingProbability] DEFAULT ((0)),
[Units] [int] NOT NULL,
[PotentialSales] [decimal] (18, 4) NOT NULL,
[ActualSales] [decimal] (18, 4) NOT NULL,
[Quality] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ResponseMedia] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OpportunityMainSales] ADD CONSTRAINT [PK_OpportunityMainSales] PRIMARY KEY CLUSTERED ([OpportunityKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OpportunityMainSales] ON [dbo].[OpportunityMainSales] ([OpportunityKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OpportunityMainSales] ADD CONSTRAINT [FK_OpportunityMainSales_OpportunityMain] FOREIGN KEY ([OpportunityKey]) REFERENCES [dbo].[OpportunityMain] ([OpportunityKey])
GO